SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364500 LIMIT 1 [ RunTime:0.000518s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364500 [ RunTime:0.001446s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934200,244960,661125,204516,391403,405135,130267,334872,659919,271474,709920,762381,262742,351269,138582,115901,310044,813406,838149,454544,172448,701397,509754,340817,177642,888483,820158,839759,1040740,283672,679839,494731,677433,446950,321605,443000,249170,756661,6969,773193,139542,959217,817531,183389,348178,1010041,191258,850416,362559,945711,1011070,573457,564793,496659,260395,393167,696427,874270,1015278,158163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]