SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541425 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541425 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624986,368440,805346,456603,941914,871716,712398,719520,225389,250377,343395,522135,741898,858081,261398,434697,846316,414745,968965,871903,313075,465362,60882,741594,957199,31822,466653,925413,72458,222173,674006,270378,720329,403732,959171,29465,187119,506062,447287,1026610,512774,111925,70833,820541,592320,874102,779000,856039,582902,412562,675982,624443,1006758,493891,250682,789522,786675,480699,300505,77298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541425 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541425 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]