SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597198 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597198 [ RunTime:0.002628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38323,471085,378204,86330,399917,845444,142924,1001439,924512,977980,105353,772288,102205,806713,845425,15907,231450,1025271,142645,121782,842625,598364,68368,545564,625236,786311,38162,784363,432186,46283,794813,921820,603402,836559,178735,878357,68432,655102,280774,690521,932773,1033300,6739,811329,880015,997742,863253,838061,70039,918623,421324,77853,763502,130311,627487,576771,1021444,739518,821087,48697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]