SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687654 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687654 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173082,668779,176259,497667,660517,122536,1028028,508771,254733,954026,599163,918584,447101,184996,218927,245285,48547,404294,1043244,545679,882178,410019,1005158,669577,760425,59338,953330,144441,589396,142641,220482,209639,554435,340580,839297,213384,917236,571746,690967,278078,882963,618171,334846,110354,241563,489016,281748,90089,237606,1016446,834019,986641,762715,755401,884226,38499,786792,37527,721105,496798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]