SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499141 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499141 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (713618,857473,191047,180261,269240,1015676,25530,5409,214465,611267,747379,504570,899320,248233,71898,1025173,775379,417081,55731,959539,55151,780507,925880,836866,142091,767850,1016316,390206,623902,928140,268671,973704,666582,959479,384768,781055,850279,180676,898622,669804,444243,703223,1040897,1030142,301387,225452,722492,144312,107210,482207,675639,686799,715931,225723,355869,516021,983355,724242,616985,397485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]