SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601105 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601105 [ RunTime:0.002180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (536520,200931,59067,870421,690319,224083,134609,247457,53585,559516,280423,337740,98132,603414,215738,674632,609898,960272,446041,925414,43800,1002727,915460,782949,791225,178770,197093,320241,852521,680026,133572,155443,195897,93866,933588,542358,986541,205381,49462,435853,248322,1017826,649405,497966,448666,461957,714269,391172,446547,883968,292536,2089,147069,713850,404132,718929,346076,829716,862392,574741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601105 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601105 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]