SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453010 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453010 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878123,978543,958017,332533,303757,66655,476049,183522,25054,361078,510255,54700,339098,572255,983856,400647,612655,726005,286152,1046396,56889,687203,825570,415279,88505,122718,131467,170190,866566,409294,1029680,1029904,1044631,296037,1031087,257723,813409,627078,568800,990716,538658,405807,325351,481735,328069,900013,644594,979404,893784,682268,194815,737460,319290,395772,914528,1035166,393498,855336,886392,94969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]