SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545551 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545551 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (562288,207250,1006806,344476,597121,49594,823419,955602,538297,258167,642313,754487,871711,343300,8668,782897,888953,534123,260170,520874,837627,212549,1003736,1008534,960295,332512,506083,536435,856697,1043854,42000,789543,854207,366243,569872,8473,827383,524485,40147,590849,702192,223381,303438,612053,715987,869203,732191,660438,489256,245191,589487,947335,7216,280560,136270,410311,85810,835083,952331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002003s ]