SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429634 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429634 [ RunTime:0.005896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391551,983110,400068,67796,936369,997062,49764,356005,955187,101580,6044,987134,536241,1022979,285206,252735,259526,899167,378325,69581,547374,333101,914351,261888,274725,402696,198854,996040,36144,601377,361140,767415,485630,553816,770619,748285,702696,938270,535978,13141,607283,577688,366754,202325,886107,365820,1030391,627825,853686,59245,828345,962243,626942,356237,616214,713623,211237,344366,484506,339702) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]