SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403738 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403738 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265184,725361,988657,344075,185003,631061,754598,878699,661479,257012,27000,1010243,730426,780337,367640,1032359,312314,196313,976115,781905,3958,736968,326325,46575,834944,376853,232965,779217,194126,713930,411810,337758,941873,758747,640848,941361,780502,288190,995773,528706,77104,497691,316159,645879,663799,288993,452869,449248,399527,300453,375923,294953,454464,19175,404887,228455,725321,243301,512818,122956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]