SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473584 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473584 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019296,287766,269254,2950,428082,829132,239704,450338,6999,423983,18007,917803,811192,247696,470497,476668,187723,608214,749068,382564,389283,1036814,53086,708934,725584,746890,349379,355831,87818,554738,525061,1046281,568167,814542,942881,811987,236469,177777,58486,787489,156737,565878,787447,836286,647113,952333,149226,803247,551555,551393,604337,486111,138138,174578,144523,961344,845776,546948,38075,548886) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]