SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419643 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419643 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502975,794857,178680,796484,410760,532447,752944,106955,862409,223723,572917,1032885,525634,383891,504039,957242,23147,393955,3511,148582,518967,288668,485279,427479,378831,920985,702349,699162,885423,741583,808551,642173,871478,349888,870052,855934,536830,953846,297328,705106,21407,1001983,714755,23123,425477,237871,113579,52660,650906,21779,243084,325033,240770,337884,162731,498571,433619,480639,732547,369191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]