SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105228 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105228 [ RunTime:0.003503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340359,187980,731616,954931,692991,123679,361665,536028,215189,756875,875105,180816,28014,562878,759097,43273,120944,158134,305810,50965,543240,544979,157359,970877,698175,422465,976321,857353,868557,25484,806256,50985,71132,194190,1027908,1046181,166699,391736,217165,172445,682732,975321,883302,390613,362239,63947,216910,694898,920928,211822,895652,194819,804260,823548,558881,549223,267164,422639,543514,163779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000423s ]