SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150712 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150712 [ RunTime:0.002214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125210,236457,454180,103055,467351,152646,698989,843231,69516,611897,345139,907004,869718,187224,277565,162067,297004,91271,403711,927347,756423,142783,541537,739030,754982,570666,112340,238414,572646,265306,170586,721051,1019369,507624,1021016,912590,39857,342974,679122,261907,352821,334091,12872,130297,415440,749308,693224,525893,664902,900147,741262,575571,126085,456369,989170,278903,629066,739318,155540,357713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]