SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 130102 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 130102 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030748,341619,904798,246501,138488,79896,302058,273557,479869,672539,340662,1019924,448561,404208,804411,846970,923216,792182,500163,646207,954085,142162,972731,89739,319305,348161,461286,318438,822685,752731,828304,494678,306016,846471,873085,677201,369200,588598,727922,152942,510471,865984,833202,885274,55651,390058,141836,335327,366042,804494,417808,1035552,169203,645615,1042253,124152,618159,146248,670720,510508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000918s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 130102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 130102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]