SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574409 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574409 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845593,823873,487581,274402,389918,505601,857760,763639,296431,945324,99663,560912,1031618,194053,634394,336792,309104,842084,331934,362335,560343,129839,701358,624065,222714,211471,685409,231205,984657,224955,29208,146071,124981,490169,838382,658056,318320,76758,135711,193885,530606,257879,942070,25881,85312,175735,999376,588321,1026328,873166,122657,662444,45789,967006,243192,576673,158897,645563,245086,408352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]