SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106405 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106405 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300757,737891,203664,741950,511078,890974,578390,663861,478070,459392,170036,565643,827681,592171,870874,419659,155967,953640,1025753,855516,766265,586878,753841,252753,12056,785273,374200,300480,58255,590072,436574,587538,872630,377007,617474,79360,1022455,101374,241730,980150,887402,746412,893967,679622,370044,233639,886112,724381,425260,302011,820676,248314,983210,1031033,934299,297878,398867,1006849,256997,725095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]