SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001749s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403804 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403804 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684901,394856,994321,355554,21080,358968,860303,40398,380969,953208,850702,752726,46556,46396,417175,284952,829687,915521,215825,970798,253979,408789,148103,1555,16018,833657,613866,629851,240225,349718,459419,617135,98612,1004218,548545,504554,684785,725898,988947,614559,947523,365716,71672,477420,215988,506354,844534,1039544,41773,995834,672905,126318,312019,742006,551715,478304,196181,75214,969611,731656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]