SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531741 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531741 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504425,726276,282982,593824,124455,630920,721600,455651,91190,302745,139368,53533,741502,245589,981705,307248,636136,746082,411437,483401,287582,362699,540845,365593,404924,659049,701358,682159,177311,1018621,320275,148027,632280,490928,122933,56376,866889,297280,233242,1017037,567779,427291,388399,331736,730663,265355,300467,658381,812549,683277,849799,733475,74780,159386,905665,334390,293663,452052,198427,765523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]