SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474846 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474846 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (922981,747963,447030,745850,530933,122507,224056,699825,936845,100152,361945,12937,665480,424943,953869,141510,745987,630172,1040878,716060,352509,1036356,754693,108045,407179,220672,363715,897155,1041021,901543,40875,169051,605415,1042425,329454,609331,385739,741984,29129,289016,861049,1038074,1025451,363689,837208,802380,483459,296323,270084,686324,399377,863378,905639,947514,560218,748374,266689,176719,240680,645041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]