SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482380 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482380 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151256,301029,382590,356845,317199,110560,43397,718611,230364,171539,883808,537373,650374,443091,550712,539495,181508,437351,305976,385870,840046,853695,1022594,730849,896443,500654,898735,382432,874242,719927,112072,709015,893510,195012,875877,894751,254860,335770,780247,813960,905202,1037595,396376,859243,156817,681051,772014,136112,631047,993199,1042175,450207,1043166,862175,110612,469748,1040334,837338,663340,376318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]