SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401248 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401248 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (134797,766826,226888,627697,46260,1043332,711884,809266,305053,293107,190110,205334,964611,959456,997439,810183,324506,102335,725765,609038,689491,820719,388677,101373,409532,789618,47866,635434,403339,1006999,60838,116085,1038654,469819,585454,610740,865889,86883,646150,660953,641356,425921,490257,274380,228642,677600,552903,532159,252055,650383,829068,928244,805143,673532,872724,493184,314812,760770,848462,352039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401248 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401248 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000930s ]