SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046503 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046503 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572544,518847,458982,479832,114480,297716,71996,126799,1008660,1006132,192960,664643,55214,18932,861901,47794,44971,349939,575827,803056,662373,611256,487987,962941,155495,735915,296029,459443,956400,14661,715894,618183,61566,938653,249526,416443,236253,557150,601495,137022,784419,914881,776049,718558,719138,665060,373184,492493,237736,844502,980370,831910,608657,928473,961987,758039,681389,188332,904201,15457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000389s ]