SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803912 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803912 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303442,455084,1026581,930674,973243,184340,808410,119085,115806,488331,663782,276817,73926,528156,295401,100295,149283,523038,191017,509651,609502,804246,889704,128363,76822,1027167,332227,248623,374761,744978,892771,495740,124777,635794,636177,100439,554005,219156,634576,435290,262660,359082,97703,973297,80550,1015478,863175,99189,5871,433435,726401,611895,345512,230170,356712,238809,458592,741519,860325,990675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]