SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317271 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317271 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40820,672727,202674,974107,731535,805400,1041057,616035,415030,805963,137386,823953,73590,133045,222296,354233,1010951,332755,105609,81306,405211,402975,503871,869538,112519,216297,737421,467596,341268,304282,468332,161591,955198,135528,599917,547851,968641,598533,483027,344287,453818,645652,258190,108586,673104,415828,815021,344389,765125,379570,680287,33122,746815,475975,714557,804934,199449,182740,584562,800214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]