SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 153801 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 153801 [ RunTime:0.003855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845987,557049,405955,828433,845092,247009,664218,657793,411632,859149,796840,533416,370044,1016521,384488,893317,135015,60488,179299,26689,668189,361301,305018,342936,777236,614658,850151,706381,947233,97454,50733,924086,862117,287460,566884,666021,638402,197235,767370,1030746,957750,613202,299838,356170,618500,268616,812978,889343,718962,690783,927231,360401,889399,387156,967868,239185,1009749,320662,211963,67991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 153801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 153801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]