SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 810396 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 810396 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207217,470176,21542,407520,219130,476934,159566,1015490,846862,92410,733081,1000463,40123,208593,603490,291975,553404,333642,315612,747416,350658,99208,888199,582189,181635,358777,569978,1035454,205879,1029078,959747,23001,198465,681798,877059,351516,325636,1011374,896381,777854,545471,253518,570130,265954,1008118,265430,865385,1014319,411489,440451,411112,702925,264472,516759,877899,207355,1045,451846,623974,399961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 810396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000880s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 810396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]