SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022293 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022293 [ RunTime:0.001596s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213850,674434,349825,9922,561366,1033673,284841,171903,1025911,439287,158495,688534,102047,295685,1046809,208184,284844,380517,495925,657315,691245,123171,91067,363899,279586,63978,487334,649288,410881,288909,155715,995775,851508,679269,450354,687426,103480,886496,527746,833570,988194,812521,530694,1021633,777427,906832,127750,518302,323154,186983,952052,500355,598987,1024462,134048,200640,888419,285040,311454,308817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000707s ]