SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 223147 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 223147 [ RunTime:0.003468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415277,482247,101163,9553,1048391,308024,552881,884660,329189,1044546,786660,242854,397738,633707,834280,975407,957544,356567,231927,344588,548951,613627,444547,242904,331831,136340,223817,302799,637554,290004,598453,645980,110303,231410,790284,615927,180532,2812,811409,276677,1030794,373932,1027609,324248,372769,353250,111464,564269,825157,688875,909882,774394,1014839,789013,798612,977322,446653,935032,545816,874512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 223147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 223147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]