SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 325545 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 325545 [ RunTime:0.002959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482001,939655,794574,142407,131203,874967,489998,734800,782430,417181,854381,758325,653339,328232,910479,304563,121070,743015,694187,443766,998344,76448,461332,788486,487318,461159,770673,162005,621742,141157,144790,424490,270691,172585,553020,241547,726697,67102,484964,12253,183237,483338,421790,323232,965269,917149,824828,13208,1031888,604220,660460,293227,795354,472297,614140,557302,25955,135961,679065,582119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 325545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 325545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]