SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518880 LIMIT 1 [ RunTime:0.000588s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518880 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (755921,316844,261306,69220,14919,624707,723617,965397,200970,722213,1037116,901099,956799,897460,993000,19158,510806,606221,132697,588238,548454,1031519,875406,84564,354076,637700,659099,256691,865728,893402,1006505,346627,631551,971899,264676,859846,440556,446101,135271,945053,15131,17042,529211,833154,497454,632578,400589,429549,585101,133138,468055,1037558,104979,604563,407941,323513,873641,171043,1044699,66597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001349s ]