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` = 269523 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 269523 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493971,770779,300042,410593,748018,663233,811875,584580,558617,856114,52848,554447,778159,374712,167761,283650,602036,240860,817183,535027,1040498,590886,306761,316487,180566,114773,755627,412508,920981,235913,700438,855347,371904,373344,959565,46333,774372,664066,968626,656209,96817,264765,323919,335803,844279,1029666,134135,237551,160618,64337,827155,888991,523750,942750,971460,76875,732370,862632,452966,98358) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 269523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 269523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]