SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451948 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451948 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (980991,200576,277409,118,334587,411359,341451,613968,89335,357372,261503,895231,927100,740119,338963,979461,983217,913509,945623,268108,871306,611642,394202,887578,938970,776994,801143,1019877,106754,190236,925874,645472,284384,657961,244320,432354,498445,406492,918868,156040,1033154,537235,132021,130896,942033,951810,526196,143186,822518,856555,625988,100867,81924,139105,958001,1019637,607381,130138,1043958,791104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001584s ]