SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499416 LIMIT 1 [ RunTime:0.000559s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499416 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580230,157851,603096,909522,489667,269638,76373,698790,735363,862804,377247,951914,629785,673207,1007043,224826,650323,771216,393815,252583,321446,205668,251356,210275,45964,1012799,1017147,443286,1007278,72290,220229,197116,904257,85254,230498,307765,140881,1034312,176386,670659,820453,384427,277080,939673,559746,150861,799148,925170,990987,985496,547588,687874,938935,32654,427710,902825,655107,445933,178390,378526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001622s ]