SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103327 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103327 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118728,718989,117219,121397,938652,721839,672824,4252,755462,640774,20803,657514,527028,291564,403651,187031,785273,218412,161770,361586,394497,375448,434442,452155,1004238,571867,153591,287010,155825,635293,423535,877937,152984,662298,1039480,666483,959103,197940,588841,966944,827719,857382,773039,1015522,302811,327503,755010,687658,826069,577504,859058,480694,1023409,271866,329235,511817,57363,362318,763238,680772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]