SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412208 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412208 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421221,266430,465176,933635,18284,894039,145487,608240,389288,621278,15414,247115,788566,115472,691324,641577,847479,552424,567626,403461,935076,995730,614285,495677,933415,229780,394208,464086,848731,504823,888173,108336,684776,61638,453527,658514,447429,48415,117578,586978,942289,432171,190548,946892,938933,571840,254615,684384,1045488,582847,781668,549359,249069,587502,832772,602418,141392,39204,734469,155690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]