SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011998 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011998 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413381,350932,1015363,290650,19945,653329,734290,48742,26480,389117,734210,694660,6238,761237,134951,1013201,505144,879445,875305,134901,339251,851148,262927,358964,503637,571360,677490,883216,294375,583444,513995,450179,127098,61728,618722,519979,467629,750138,602637,185351,684222,27192,674723,930160,196823,736847,469899,715623,705955,502403,475438,62760,137499,1002838,300085,496096,811131,879128,707553,329990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]