SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511314 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511314 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939667,117481,567500,139021,912462,337312,515410,496795,517206,416101,608696,274964,650020,743563,857367,548755,293295,551566,736485,983209,558623,81413,555283,669952,599646,786985,526615,682745,634575,1007097,796835,852964,791725,760984,776773,921376,243629,369393,924637,608626,423859,581470,558195,917544,794893,310629,951653,575762,879576,775848,136589,653575,462996,27682,49351,314944,491803,523200,445385,459011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000925s ]