SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502485 LIMIT 1 [ RunTime:0.002249s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502485 [ RunTime:0.002983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450427,191467,21490,491286,784074,386871,589374,684244,151043,810521,194096,654218,552983,707079,379564,595995,623354,935070,50331,216052,916663,357212,951094,934788,977044,717716,36648,803229,443179,221407,757690,40880,180124,153114,805480,743340,692218,487157,974145,333049,686287,952021,303509,551145,701948,113352,909099,638769,540847,88552,254605,875541,1015246,896105,698860,954273,744996,614840,910695,911940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502485 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502485 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]