SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546046 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546046 [ RunTime:0.001459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558838,522638,769790,17810,428890,20228,266981,969032,43006,792120,73935,17188,436948,636257,359284,1040469,659807,1017358,743961,523971,1027358,313669,670171,166536,655695,272660,789602,610029,165565,690042,718943,708513,167652,155932,675291,153774,513945,442495,830537,982606,588918,553164,94485,681389,729370,1015239,6364,825377,926268,1032292,542427,864086,934718,360697,510353,547713,706943,722590,623390,919658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]