SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454201 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454201 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797044,181268,1017794,451700,482656,249699,860141,558115,587640,759901,481100,185421,681254,824724,841134,404809,623987,748391,226968,378878,291513,213578,790629,821698,715233,923544,161621,918152,728674,566705,41322,981238,354129,224827,502022,875716,730520,842000,663252,423336,361288,1001971,393673,605331,984130,1040966,982348,684054,903242,587861,343690,806155,448867,156327,589312,850689,31398,512371,548745,685303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]