SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427481 LIMIT 1 [ RunTime:0.000525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427481 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844830,607911,1047870,210611,111695,437334,535777,590874,185002,39045,913449,839971,996737,211157,170169,404049,686526,231871,724215,127592,400158,641429,176128,630298,752333,152317,92325,771584,615248,102143,878439,725277,40600,694120,416441,922223,231078,670846,1042293,332768,1034190,837621,464897,741698,308563,141366,219255,907915,644046,292741,534594,721858,1032941,903698,443285,985895,48269,576939,979590,257343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]