SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802141 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802141 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719270,400325,64488,773512,557864,465977,948703,716577,1039553,789340,354157,1048174,521336,435206,119963,267375,820767,344828,407616,377648,10369,862318,137383,26676,602560,186066,1001568,370068,680950,305954,309015,318218,313050,225545,174513,411966,119560,65847,283288,926345,414847,749649,422859,493968,207195,360824,1047996,643904,306617,486382,349156,627897,296189,121727,215056,627252,293212,747856,951529,10747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]