SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101402 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101402 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689740,1333,527505,435463,512587,144046,543444,383456,309234,451702,18732,23928,799274,520339,24317,901340,125235,594710,368736,370883,358168,50686,245782,988025,212653,40540,584819,325964,308198,145661,930728,606094,971856,387900,366031,295248,600114,198220,197767,1011253,116201,203873,27185,1029058,699987,428154,120622,904659,850949,484852,889886,220205,100142,145167,67580,648461,1021861,656090,845062,712635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]