SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508740 LIMIT 1 [ RunTime:0.000788s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508740 [ RunTime:0.002873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719803,604970,439811,381157,109415,17801,947253,923069,1033157,851400,64429,11489,116740,474248,428604,141813,480817,84578,327411,411126,304984,313909,519945,239369,454841,763934,163727,455865,127871,483511,764654,239010,321476,246621,147499,793545,35633,118721,96630,899020,870285,687318,359140,305838,9975,283256,136750,1011206,549208,342393,515742,495260,282609,180842,942482,958241,38401,835933,422480,493617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001490s ]