SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522180 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522180 [ RunTime:0.008674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736997,82006,542159,783389,626892,534613,651416,43086,393566,27321,548332,279803,68731,520643,890709,694817,376677,789461,150559,908415,731487,774236,354210,819493,443721,966419,498314,158917,222248,196778,74398,824265,567498,512448,874707,513967,541494,679282,517790,956781,295593,494766,12039,927933,397248,1017900,808892,389462,544070,521747,94576,366044,817935,575695,942830,1038184,228769,452049,156268,823509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001369s ]