SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536072 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536072 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463585,445257,692123,18808,725488,926781,264133,274624,147120,948969,575721,777455,476186,570909,866256,149542,166909,799693,975262,489037,775115,781784,496334,814198,906805,310849,420332,59713,958066,64287,194649,485003,806811,512748,755515,853670,283190,200328,289930,754223,486958,943216,703778,920980,246331,627966,914821,1041525,799940,935170,659668,643537,32410,468121,686574,107477,1002592,116451,87584,171806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002758s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]