SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404300 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404300 [ RunTime:0.001446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267051,801651,1025859,1019521,753237,378953,718790,748920,772726,693968,985018,889854,120558,729456,971680,352604,919606,106993,663430,939906,263560,728409,1047202,588145,779029,25877,941730,906284,71192,92101,770912,862936,549753,725472,553561,302306,716995,594893,976913,329592,201497,345678,35783,907926,587596,430949,621922,723605,726110,388285,113360,903963,651900,655670,423291,466988,208375,426809,524908,27982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]