SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414098 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414098 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393788,656920,380488,342353,998,1015995,750762,858948,438946,95672,816454,352261,205734,139265,193690,33717,872968,95643,644347,701873,812940,731045,453729,974646,942864,606333,356666,969727,943188,857495,331613,425777,361611,905061,1025061,240019,934344,373764,807584,766959,738234,325311,769121,180986,1178,804504,643782,925403,693518,402011,413802,982433,1041917,819163,946303,263155,771908,186208,482818,749555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]