SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548253 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548253 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194486,142548,462266,436792,899721,320170,323754,1035194,833664,226613,615246,1017262,369517,527017,369711,429432,226645,94129,977420,794738,159451,379898,414810,10880,624461,540792,476580,899363,435984,52865,377912,817218,427158,25264,561842,397544,808696,756638,600321,379656,420834,300238,943280,265129,880950,733660,787745,978354,393409,570797,69834,1037878,498196,590801,541795,898051,311976,944884,294577,587101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548253 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548253 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]