SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418709 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418709 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821544,42447,911552,287923,110329,38625,1004482,1018565,105826,1043485,502198,150089,145588,831957,1005661,167346,608385,588670,12088,50218,683154,833779,630631,363950,357459,194114,826385,1018887,120309,435908,824518,950789,1045721,332054,166306,540746,1004305,727134,762976,572451,333060,131294,80969,512791,155077,71168,881176,154477,89180,714046,399127,965510,349025,236613,759423,760198,354451,733699,902600,535828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418709 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418709 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]