SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435621 LIMIT 1 [ RunTime:0.001078s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435621 [ RunTime:0.003280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979903,192134,939138,381136,190288,790289,1002441,326427,385401,1024945,474110,368647,672222,965749,8081,505198,595127,620196,822273,879045,398763,835812,946906,782681,74547,821005,481349,844658,532044,532536,587500,269914,534869,794462,341101,370002,694525,452543,978135,856180,271505,208189,497511,821412,54461,591594,419742,892677,248891,821109,431536,707916,197110,103968,535076,904762,83847,107727,565169,54723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]