SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196389 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196389 [ RunTime:0.001761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776817,447495,1025404,204561,570696,13009,464102,389793,485639,24214,120598,312678,563699,802898,725095,146569,450416,120994,635093,274680,621021,128189,747229,776634,749178,802109,168797,108533,652197,496583,527472,408855,1029690,609408,952075,14950,20844,160100,619661,294532,730358,379677,977809,1021236,101872,614909,805694,933604,368600,222172,32929,477770,728576,583556,63050,11747,359248,668914,734259,79989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]