SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102089 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102089 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344287,431069,847918,256589,143698,1046736,942178,815759,778252,201510,1017778,812495,818601,234228,24672,21981,130286,55486,309459,318441,995276,166196,385160,211922,592538,325603,533529,885953,417367,672475,159976,861367,422559,633391,821066,686437,764141,882648,377489,254836,229639,281597,752407,550212,670399,524828,394716,589228,450651,394927,997725,248354,475829,702577,1019177,987047,202955,859454,683452,159763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001502s ]