SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023508 LIMIT 1 [ RunTime:0.001333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023508 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9901,565535,23062,338347,585699,444214,947225,738759,74480,346102,563962,1415,40537,408611,420764,173777,419581,128074,556407,715485,842657,139475,479082,392193,129593,515157,237665,548200,942911,840358,386524,497122,736976,991914,971443,228268,420930,817376,28677,117922,522968,342601,612644,162939,73136,186595,386506,664514,906457,186523,31596,75267,62459,247600,201705,377598,991024,597241,636235,213062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]