SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037981 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037981 [ RunTime:0.003160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (641029,301242,1023948,735955,493,264330,240197,685106,331832,198995,1011443,622066,922370,607657,869906,116389,741494,1047995,342101,47017,425628,55736,263433,325944,752791,527234,623868,180306,744493,429207,882984,622139,75415,500095,826753,881306,768054,264878,570707,705852,375263,978012,101184,759568,879674,244905,380984,542977,230563,31765,1025894,638076,872178,44779,205919,567017,533858,912466,378627,642072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]