SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402470 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402470 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670112,703159,840319,537174,390775,368769,538441,442688,1005062,13017,714171,668665,820430,281372,60774,16832,732977,262662,329114,252275,494748,665028,263854,798575,411920,755028,479729,500722,537204,431546,1011980,39447,430093,445781,573458,44418,138201,671929,985497,643430,763577,536119,276252,848587,706822,893945,29271,351612,203592,236883,348813,216242,894349,583106,338568,80458,735083,202161,899405,107907) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]