SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429111 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429111 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138174,425966,857044,36112,127565,1028112,917742,601274,423901,954022,995422,964503,572764,959814,44595,486228,1041804,284366,445504,884537,434291,717243,250929,706322,230288,938776,652173,793800,302747,367060,976208,547462,491939,494451,255164,344884,689799,909831,889596,552520,945987,766754,810414,709507,97307,1027864,238814,383979,197331,56042,219518,539107,500100,63058,476569,1019771,965961,114298,391417,26272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]