SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329201 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329201 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205926,808176,507801,632038,902115,507142,822568,196331,1015840,446310,168341,155073,44431,557026,290412,371889,1047884,744276,443967,435596,160804,225502,903416,835136,488941,793862,101750,971879,118846,108531,676588,121227,779429,174632,1027992,750333,885372,484003,32725,335421,347509,684059,303177,363446,250332,892494,993439,785086,539374,219432,603300,979528,512824,1030085,1015147,145009,44885,172466,985248,705303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]