SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545857 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545857 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722925,342707,237861,378937,394512,584508,197328,99402,322360,1034799,264401,452088,513842,976924,292778,447412,756756,876775,105470,246701,471244,129531,566647,147267,981955,196030,538401,455634,554907,720796,581304,965953,292776,448479,1014254,862228,785755,192939,321345,673203,430560,936111,590278,162441,428779,895543,141261,597378,559975,701434,182717,812702,666648,307909,692987,319809,68207,89702,899511,897598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]