SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541070 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541070 [ RunTime:0.002043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98605,951555,562184,349787,426475,2981,1013250,178399,415497,465206,1003745,1020960,813682,549142,228097,54646,432793,803384,179883,1008763,910210,513002,208602,566419,1001675,117158,552238,484708,740954,700804,265136,991963,73553,772617,862682,365166,150097,924923,951370,207837,326366,833150,543979,816456,187130,648236,862436,653973,369648,895287,276635,999273,771659,390688,941617,408805,443737,809576,719977,463177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002753s ]