SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442151 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442151 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607740,975182,566347,591848,832590,399908,1006843,451109,642042,242555,733423,144773,144034,886761,857906,86265,82681,352518,169972,88832,745605,812089,781163,276295,758582,800493,525537,629928,991133,165585,218209,734999,16823,535663,18944,197957,509862,360955,395689,1023462,633116,809212,650362,381560,1036394,875228,411900,343284,855966,225703,196890,29567,850903,893210,550422,353794,712272,1031774,92292,700428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]