SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 129813 LIMIT 1 [ RunTime:0.002281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 129813 [ RunTime:0.004273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201462,150081,106623,332845,305062,367642,1022828,985043,59737,935116,378669,228365,964956,141085,393821,956775,248481,351279,129271,93390,821246,724684,305448,490210,118174,251071,228773,1006735,550987,233651,730172,559682,1031241,521825,620880,14168,869490,886960,857407,317076,219759,790841,497177,756818,304276,507032,555574,92735,556088,434923,670505,548406,250306,630702,580605,147640,504286,925256,482283,591840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 129813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 129813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002350s ]