SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023678 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023678 [ RunTime:0.005278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202747,612846,637458,326596,374252,545587,243505,999351,860508,784598,488545,534996,354741,474506,585243,379480,420888,181040,127092,1033388,120437,356283,154174,729186,429712,974371,421855,149316,119055,690365,744459,11544,905080,251118,333940,478018,826721,729197,78140,612633,746975,981989,197313,349055,433382,121217,114367,471001,318694,654850,340264,671501,24678,74054,979062,699049,592650,289800,708856,113265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]