SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030499 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030499 [ RunTime:0.002447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52473,124484,242399,560869,468138,711894,956737,583872,263941,210182,315647,509799,375941,257398,78202,395594,1029483,849695,249410,371556,290982,187229,513775,494030,857083,779237,830872,387833,733784,984301,921261,684877,578872,884779,713499,17601,922055,910332,302229,88404,609675,428048,31508,152920,51435,832924,643613,34432,840608,934389,441717,176695,64501,819045,688181,155333,495623,893213,637801,914650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005227s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003622s ]