SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419628 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419628 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911484,696777,252971,352022,922418,367384,974579,939226,830691,577556,155958,477603,576513,1026921,348939,936034,639601,856708,1036961,861151,507123,810179,403631,723902,692592,811017,278610,548285,810791,263312,1040937,165211,657544,3845,584125,703168,457573,48657,223262,410629,796672,336859,67728,493214,6315,16668,602499,579440,732898,261380,463784,388825,670777,879908,286201,665091,820762,372744,756853,145743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]