SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 185418 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 185418 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10609,617292,356022,840616,270068,390428,938196,340004,290215,470943,795004,413599,189528,186736,440332,88681,575114,474271,810474,885622,674274,227870,775974,117161,971865,839999,267721,31503,242820,427243,221490,150832,622444,952694,310406,49892,978843,971366,111835,424788,130325,1024753,849597,892509,608070,735534,625802,845908,14690,664150,1000574,625666,654850,295755,371377,829152,121458,660268,333670,187410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 185418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 185418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]