SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508876 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508876 [ RunTime:0.002139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133562,774095,867305,133537,446163,539861,810879,706574,189379,569457,940461,907236,298262,277585,446141,1043120,402362,36045,715385,798461,132362,655165,936718,147630,708,933884,667426,790689,381775,758288,471563,381718,1039050,501878,257170,1041064,801670,899653,223747,943495,427094,883007,287031,960593,664050,330443,205018,602409,396584,873961,608088,313799,718989,930504,1010830,241525,878967,445040,549486,498431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]