SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 181028 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 181028 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808200,443467,740868,194775,835757,431166,860075,691410,860947,484174,773350,401673,849503,136591,695715,323390,154683,487780,807075,311205,665248,911184,870888,728323,691924,593559,717607,170083,586266,789968,243644,206196,49409,181326,652267,321552,879695,897404,760223,567341,696632,308370,498120,884249,273642,567744,129147,430549,845954,707629,585329,925358,948792,636998,436162,448511,681033,628628,885751,45991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 181028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 181028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]