SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043383 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043383 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879092,1757,799316,84742,875388,558602,345336,319011,243135,42403,1012404,689109,568551,56168,953638,994172,468180,226644,255031,502759,420254,257339,932788,394120,6049,662166,32832,864185,129605,799251,596878,137632,384380,419854,506265,231336,853761,946986,320782,508544,814863,598366,177215,354723,223443,96947,500539,695793,183252,637776,290417,966821,389243,333581,345151,665740,904045,115303,234914,1021012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]