SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402102 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402102 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467046,498365,1034814,366447,1042403,442232,851041,323423,590983,1041658,30175,742448,105020,539861,310400,753426,5989,717188,146014,955216,457038,339451,520739,348851,136114,131685,144303,996718,700357,940373,416739,635755,210358,905320,192326,643082,15392,471504,453742,192841,465765,48092,1044511,552903,868244,1034209,821922,803484,833974,634101,1017154,227415,860372,591526,1030492,644666,322771,98819,106183,496500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]