SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 269184 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269184 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401987,241828,341379,606593,517429,1008491,766921,356190,488217,237427,892749,793638,418698,775189,135515,409348,1026866,97134,295716,807591,662047,369100,691650,383475,927532,209094,58668,453935,445062,77041,1038236,616488,51562,700998,628251,8386,40704,411948,369471,66256,688400,137981,184325,324165,900980,686055,531504,265550,917984,818241,330578,218615,836271,307517,664038,551850,911579,836164,368552,823090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]