SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019904 LIMIT 1 [ RunTime:0.000802s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019904 [ RunTime:0.003755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714550,438498,112374,630003,103842,827524,204502,80126,879979,860856,817107,947884,264798,132927,649965,374999,997391,243768,136016,950264,625813,967762,369227,101026,212833,657143,1011367,751038,99305,881163,465637,226868,599852,735340,446660,896556,903675,1007264,927739,691883,845090,207224,57454,720760,401005,176774,22192,63122,412776,1322,604397,291626,1004917,584138,443228,528936,943472,331186,599682,45431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]