SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490490 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490490 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840018,3760,774047,227856,646128,806275,892633,971236,550337,78587,899665,213795,626301,28656,858082,1044069,206457,884545,793655,1035739,621903,1000018,101004,994976,752918,651764,170205,12249,887548,101825,144787,56451,343205,505028,982991,45627,861944,858473,334534,346201,417528,781124,519868,215455,53278,816614,970928,123450,759455,306730,836078,485135,226998,770257,543516,391508,859582,445891,75504,780067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]